Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by bsharath
at 2024-08-04 05:29:16
ModifyPoint:500 Replies:6 POST_ID:828697USER_ID:11591
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Office Suite
Hi,
Add - between words and remove spaces
I need help with a formula that can add a - hyphen where ever a space is available.
This is a line in cell in column A
Should be
This-is-a-line-in-cell-in-column-A
If we have a space at the end should not add a space example or start
-This-is-a-line-in-cell-in-column-A-
thanks
Add - between words and remove spaces
I need help with a formula that can add a - hyphen where ever a space is available.
This is a line in cell in column A
Should be
This-is-a-line-in-cell-in-column-A
If we have a space at the end should not add a space example or start
-This-is-a-line-in-cell-in-column-A-
thanks
Accepted Solution
Expert: duncanb7 replied at 2024-08-04 06:20:09
500 points EXCELLENT
=SUBSTITUTE(trim(A1), " ", "-")
that should work for your case
that should work for your case
Expert: duncanb7 replied at 2024-08-04 06:18:22
=SUBSTITUTE(trim(A1), " ", "-")
You can trim space at start and end of string if it has
You can trim space at start and end of string if it has
Expert: duncanb7 replied at 2024-08-04 06:12:55
This is a line in cell in column A
Should be
This-is-a-line-in-cell-in-column-A
it will solve it exactly by =SUBSTITUTE(A1, " ", "-")
If you need other requirement, please open new thread
What is the output after using =SUBSTITUTE(A1, " ", "-") ?
please send it to us if still issue
I got from my excel that is "This-is-a-line-in-cell-in-column-A"
Author: bsharath replied at 2024-08-04 06:12:25
Thanks
How can i remove the start and end blank spaces
How can i remove the start and end blank spaces
Expert: Emmanuel Adebayo replied at 2024-08-04 06:05:35
Hi,
First let me ask, is this line of statement in one colum? if yes you can achieve this by find and replace command.
i.e This is a line in cell in column A to a notepad or notepad++ and use find and replace command.
Copy the output back to excel.
regards
First let me ask, is this line of statement in one colum? if yes you can achieve this by find and replace command.
i.e This is a line in cell in column A to a notepad or notepad++ and use find and replace command.
Copy the output back to excel.
regards
Expert: duncanb7 replied at 2024-08-04 06:02:33
=SUBSTITUTE(A1, " ", "-")
Is it what you want ?
Is it what you want ?
