Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula where I can add word to a entire column .
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
09/02/2018 - 07:43
Hi there I expert.
Excelchat Expert
09/02/2018 - 07:43
hello
User
09/02/2018 - 07:44
So i use google sheets and excel
User
09/02/2018 - 07:44
is it possible to get formula for both or just excel?
Excelchat Expert
09/02/2018 - 07:44
okay
Excelchat Expert
09/02/2018 - 07:44
I can try for both
User
09/02/2018 - 07:45
So i have a column of #s and wondering how I can add a space and word or letter
User
09/02/2018 - 07:45
for the entire column
Excelchat Expert
09/02/2018 - 07:45
do you have the file with you
User
09/02/2018 - 07:46
can you see the document preview on right?
Excelchat Expert
09/02/2018 - 07:46
yes
User
09/02/2018 - 07:46
its not the whole file but example of the colum that needs
Excelchat Expert
09/02/2018 - 07:46
sure
User
09/02/2018 - 07:46
a space and USD next to each number
User
09/02/2018 - 07:46
(and for future, sometimes the space is not there just letter or word)
Excelchat Expert
09/02/2018 - 07:47
after the number or before
Excelchat Expert
09/02/2018 - 07:48
something like this
User
09/02/2018 - 07:48
after
Excelchat Expert
09/02/2018 - 07:48
ok
User
09/02/2018 - 07:48
or is there way to tweak the fromula for future where i can add before too if i ran into something that requires before?
User
09/02/2018 - 07:49
In this case, I need USD word not dollar sign
Excelchat Expert
09/02/2018 - 07:49
ok
Excelchat Expert
09/02/2018 - 07:50
if you know the criteria when you will need it before then
Excelchat Expert
09/02/2018 - 07:50
may be I can put an If formula for that
User
09/02/2018 - 07:50
perfect
Excelchat Expert
09/02/2018 - 07:51
if you need it before then just put the USD and space before in the formula
User
09/02/2018 - 07:52
Nice... i tried to find somethign like this but took me too many hrs
Excelchat Expert
09/02/2018 - 07:53
is there anything else you wanted to know
User
09/02/2018 - 07:53
where can i find the formula?
User
09/02/2018 - 07:53
i think i found it
Excelchat Expert
09/02/2018 - 07:53
yes next to the fx sign
User
09/02/2018 - 07:54
so i just do the drop down fill for the entire column after applying it to the first cell?
Excelchat Expert
09/02/2018 - 07:54
its called formula bar
User
09/02/2018 - 07:54
google sheets and excel are pretty similar right?
Excelchat Expert
09/02/2018 - 07:54
yes
User
09/02/2018 - 07:54
this formula should work with google sheets?
Excelchat Expert
09/02/2018 - 07:54
yes it should work
User
09/02/2018 - 07:55
ok so A2 if my column is M2
User
09/02/2018 - 07:55
then it should be replaced with that right
Excelchat Expert
09/02/2018 - 07:55
correct
User
09/02/2018 - 07:56
Is there way to quickly fill down with the remaining columns
User
09/02/2018 - 07:56
when i do fill down it goes all the way to the bottom like more then the sheet
User
09/02/2018 - 07:57
Like the sheet has 1000 rows right
User
09/02/2018 - 07:57
But my data has only 883 rows
Excelchat Expert
09/02/2018 - 07:57
you can drag down till the row you need
User
09/02/2018 - 07:57
so when i fill down it goes all the way to 1000
User
09/02/2018 - 07:57
When i drag it though and data is really big it can take quite long time
User
09/02/2018 - 07:58
and when i select the whole column it selects all 1000 and not 883
Excelchat Expert
09/02/2018 - 07:58
the other way to do is to go to the last used row of column A
Excelchat Expert
09/02/2018 - 07:59
move to column B and then select till top using shift arrow
Excelchat Expert
09/02/2018 - 07:59
and then do control D
Excelchat Expert
09/02/2018 - 07:59
ctrl+shift+d
User
09/02/2018 - 08:00
ok... or im doing similar formula to other columsn i can cut off the unused rows and im able to select all column and it will select all with data only right
Excelchat Expert
09/02/2018 - 08:00
ctrl+ arrow key can move to first or last cell
Excelchat Expert
09/02/2018 - 08:01
go to last row by using ctrl +arrow key
Excelchat Expert
09/02/2018 - 08:01
do ctrl+shift+up arrow
Excelchat Expert
09/02/2018 - 08:01
it will select till the last used row
Excelchat Expert
09/02/2018 - 08:01
do ctrl d
Excelchat Expert
09/02/2018 - 08:02
it will copy the formula till last
User
09/02/2018 - 08:02
ok... got it..
User
09/02/2018 - 08:02
thanks for helping me save lot of time
Excelchat Expert
09/02/2018 - 08:02
welcome
Excelchat Expert
09/02/2018 - 08:02
thanks and have a good day
User
09/02/2018 - 08:02
chipmunk .. you gave the name to yourself?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.